Options mode
To specify query-tuning options and other query parameters, choose the Options button. Query Builder enters the Options mode and appears as in Figure 4–11.
Editable find, join, and field list criteria
To support the QUERY FIELD-LIST feature, Query Builder displays an editable browse with the following fields:
Table — Specifies the tables in the query. This field is not editable.
Find — Specifies the find criteria (EACH, FIRST, or LAST). This field is editable.
Join — Specifies the type of join (INNER or OUTER). This field is editable.
Returned — Specifies which fields are returned (included in the field list) when records are fetched to satisfy the query (All Fields or Fields Used). This field is editable.
To change the Find field, double-click in it until the desired value appears or type E, F, or L.
To change the Join field, double-click in it until the desired value appears or type I for INNER or O for OUTER.
The Returned field is a logical field that can be set in one of two modes: All Fields (the default) and Fields Used. When you select All Fields, the query fetches all fields of the table. When Fields Used is selected, the query returns only those fields in the FIELDS-IN-QUERY preprocessor list. For browses, this is controlled in the Column Editor; for frame queries, this is controlled by what fields you place in the frame.
To select All Fields, either double-click in the field until All Fields appears or type A. To select Fields Used, double-click in the field or type F.
Editable query tuning options
You specify query-tuning parameters by entering your choice of parameters in the Query Tuning Options panel. Depending on your choices, the AppBuilder inserts code like the following into the OPEN-QUERY statement:
Query-tuning parameters correspond to the QUERY-TUNING keyword. This keyword is available with the FIND, FOR EACH/LAST/FIRST, and OPEN-QUERY statements. For more information, see OpenEdge Development: Progress 4GL Reference
.